﻿CREATE TABLE [PR].[LedgerPeriodLinesAccount] (
    [Id]                    INT             IDENTITY (1, 1) NOT NULL,
    [TransTypeId]           INT             NULL,
    [PeriodLinesId]         INT             NULL,
    [TransTypeName]         VARCHAR (128)   NULL,
    [Debit]                 VARCHAR (50)    NULL,
    [DebitSubcontoTypeId1]  VARCHAR (128)   NULL,
    [DebitSubcontoTypeId2]  VARCHAR (128)   NULL,
    [DebitSubcontoTypeId3]  VARCHAR (128)   NULL,
    [DebitSubcontoTypeId4]  VARCHAR (128)   NULL,
    [DebitSubcontoTypeId5]  VARCHAR (128)   NULL,
    [Credit]                VARCHAR (50)    NULL,
    [CreditSubcontoTypeId1] VARCHAR (128)   NULL,
    [CreditSubcontoTypeId2] VARCHAR (128)   NULL,
    [CreditSubcontoTypeId3] VARCHAR (128)   NULL,
    [CreditSubcontoTypeId4] VARCHAR (128)   NULL,
    [CreditSubcontoTypeId5] VARCHAR (128)   NULL,
    [Summa]                 DECIMAL (19, 2) NULL,
    [NDS]                   INT             NULL,
    PRIMARY KEY CLUSTERED ([Id] ASC)
);

